CREATE EXTERNAL TABLE jms_dm.dm_cn_departure_transfer_timely_store_agg_dt
(
    `start_code`       string COMMENT '始发地 发件中心',
    `start_name`       string COMMENT '始发地 发件中心',
    `start_agent_code` string COMMENT '发件代理区',
    `start_agent_name` string COMMENT '发件代理区',
    `send_count`       int COMMENT '发件票数',
    `store_count`      string COMMENT '留仓票数'
)
    COMMENT '（出港转运及时率）留仓汇总数据'
    PARTITIONED BY (
        `dt` string COMMENT '日期分区')
    ROW FORMAT SERDE
        'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
    STORED AS INPUTFORMAT
        'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
        OUTPUTFORMAT
            'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
    LOCATION
        'hdfs://yl-bg-hdp/dw/hive/jms_dm.db/external/dm_cn_departure_transfer_timely_store_agg_dt'